package soft.edu.dao;

import org.apache.ibatis.annotations.Param;
import soft.edu.pojo.SchResearchDirection;

import java.util.List;

public interface SchResearchDirectionMapper {
    int deleteByPrimaryKey(Integer resId);

    int insert(SchResearchDirection record);

    int insertSelective(SchResearchDirection record);

    SchResearchDirection selectByPrimaryKey(Integer resId);

    int updateByPrimaryKeySelective(SchResearchDirection record);

    int updateByPrimaryKeyWithBLOBs(SchResearchDirection record);

    int updateByPrimaryKey(SchResearchDirection record);

    //根据院校、学院、专业查研究方向的信息
    List<SchResearchDirection> getRDInfo(@Param("year") String year,
                                         @Param("res_uni_name") String res_uni_name,
                                         @Param("res_college_name") String res_college_name,
                                         @Param("res_maj_name") String res_maj_name);

    //根据院校、学院、专业、年份筛选
    public List<SchResearchDirection> getRD_byYear(@Param("res_year")String res_year,
                                                   @Param("res_uni_name")String res_uni_name,
                                                   @Param("res_college_name")String res_college_name,
                                                   @Param("res_maj_name")String res_maj_name);
}